<?php 
    $resultname=mysql_query("select * from system");
    $row=mysql_fetch_array($resultname);
?>
<h1 class="red">Welcome To <?php echo $row['SystemTitle'];?></h1>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="82%" valign="top">Visit the About Us page for development progress.</td>
    <td width="18%" valign="top"><p><strong>Job Statistics</strong><br />
        <?php $result = mysql_query("SELECT * FROM jobs");
	$num_rows = mysql_num_rows($result);

		echo "$num_rows Total Jobs";
        ?>
      <br />
        <?php $result = mysql_query("SELECT * FROM users");
	$num_rows = mysql_num_rows($result);

		echo "$num_rows Total Employers";
        ?>
      <br />
      <strong>Latest Job</strong><br />
      <?php
// Query Database
$query = @mysql_query( "SELECT * FROM `jobs` ORDER BY JobID DESC LIMIT 1;" ) or die( 'Query Error: ' . mysql_error()); 
// Check if database returns a problem or not
$row = mysql_fetch_object( $query );
echo $row->JobTitle;
?>
    </p>
    <p><a href="index.php?app=newjob">Submit New Job</a></p></td>
  </tr>
</table>
<p>&nbsp;</p>
